USE [HomestayWebDB]
GO
/****** Object:  StoredProcedure [dbo].[Store_User_BanUser]    Script Date: 11/26/2012 17:28:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Store_User_BanUser]
	@Username varchar(20)
AS
BEGIN  
 UPDATE Users SET IsDeleted = CAST(1 AS BIT)
 WHERE Username = @Username
END  

